{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["RBC Male","WBC"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RBC Male","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,0,3,10],[7,0,7,2],[29,1,29,2],[31,1,31,2],[5,3,5,7],[5,9,5,10],[6,3,6,7],[5,0,5,2],[6,1,6,2]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 501 (version 1.0). Reference Range Verification (Hematology)_Example. Page 1 of 2"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"Sysmex XN1000",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"RBC Male"]
["Proposed Reference Range:",null,null,4.7000000000000002,"to",6.0999999999999996,null,"Units:","cells/mcL"]
[]
[{"$nulls":5},4.2000000000000002,5.2999999999999998,4.9000000000000004,6.2000000000000002,4.2000000000000002]
[{"$nulls":5},4.7999999999999998,5.2000000000000002,4.7999999999999998,6.0999999999999996,4.7999999999999998]
[{"$nulls":5},6.5,5.5999999999999996,5.5999999999999996,6,6.5]
[{"$nulls":5},6,6,5.2999999999999998,5.2000000000000002,6]
[]
[{"$f":"I8","v":"cells/mcL"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<4.7"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":2},{"$f":"B16/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"I8","v":"cells/mcL"}]
[{"$f":"D8&\"-\"&G18","v":"4.7-4.98"},4,{"$f":"B17/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8-0.0001","v":4.6999000000000004},{"$f":"F8-D8","v":1.3999999999999995}]
[{"$f":"G18&\"-\"&G19","v":"4.98-5.12"},0,{"$f":"B18/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.2*H17)","v":4.9800000000000004}]
[{"$f":"G19&\"-\"&G20","v":"5.12-5.26"},2,{"$f":"B19/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.3*H17)","v":5.1200000000000001}]
[{"$f":"G20&\"-\"&G21","v":"5.26-5.4"},2,{"$f":"B20/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.4*H17)","v":5.2599999999999998}]
[{"$f":"G21&\"-\"&G22","v":"5.4-5.68"},2,{"$f":"B21/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.5*H17)","v":5.4000000000000004}]
[{"$f":"G22&\"-\"&G23","v":"5.68-5.82"},0,{"$f":"B22/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.7*H17)","v":5.6799999999999997}]
[{"$f":"G23&\"-\"&G24","v":"5.82-5.96"},0,{"$f":"B23/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.8*H17)","v":5.8200000000000003}]
[{"$f":"G24&\"-\"&G25","v":"5.96-6.1"},5,{"$f":"B24/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8+(0.9*H17)","v":5.96}]
[{"$f":"\">\"&G25","v":">6.1"},3,{"$f":"B25/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"F8","v":6.0999999999999996}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":5.46}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":0.69992480799161916}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":5.4499999999999993}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"4.2-6.5"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0.25}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Unacceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":4.2000000000000002},{"$f":"MAX(F10:J13)","v":6.5}]

{"sheet":"WBC","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 501 (version 1.0). Reference Range Verification (Hematology)_Example. Page 2 of 2"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"Sysmex XN1000",{"$nulls":4},"Date:","2023-08-03"]
[null,"Analyte",null,"WBC"]
["Proposed Reference Range:",null,null,4.5,"to",11,null,"Units:","10^9/L"]
[]
[{"$nulls":5},10.800000000000001,9,9.9000000000000004,10.800000000000001,9]
[{"$nulls":5},10.199999999999999,7,8.1999999999999993,10.199999999999999,7]
[{"$nulls":5},10,6.7999999999999998,8.8000000000000007,10,6.7999999999999998]
[{"$nulls":5},9.5,6.2000000000000002,7.9000000000000004,9.5,6.2000000000000002]
[]
[{"$f":"I8","v":"10^9/L"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<4.5"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"10^9/L"}]
[{"$f":"D8&\"-\"&G18","v":"4.5-5.8"},0,{"$f":"B17/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8-0.0001","v":4.4999000000000002},{"$f":"F8-D8","v":6.5}]
[{"$f":"G18&\"-\"&G19","v":"5.8-6.45"},2,{"$f":"B18/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.2*H17)","v":5.7999999999999998}]
[{"$f":"G19&\"-\"&G20","v":"6.45-7.1"},4,{"$f":"B19/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8+(0.3*H17)","v":6.4500000000000002}]
[{"$f":"G20&\"-\"&G21","v":"7.1-7.75"},0,{"$f":"B20/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.4*H17)","v":7.0999999999999996}]
[{"$f":"G21&\"-\"&G22","v":"7.75-9.05"},5,{"$f":"B21/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8+(0.5*H17)","v":7.75}]
[{"$f":"G22&\"-\"&G23","v":"9.05-9.7"},2,{"$f":"B22/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.7*H17)","v":9.0500000000000007}]
[{"$f":"G23&\"-\"&G24","v":"9.7-10.35"},5,{"$f":"B23/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8+(0.8*H17)","v":9.6999999999999993}]
[{"$f":"G24&\"-\"&G25","v":"10.35-11"},2,{"$f":"B24/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.9*H17)","v":10.350000000000001}]
[{"$f":"\">\"&G25","v":">11"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":11}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":8.6899999999999995}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":1.5559393845587555}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":9}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"6.2-10.8"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":6.2000000000000002},{"$f":"MAX(F10:J13)","v":10.800000000000001}]